Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
TillTenderRepositoryID (FK) | The unique identifier for the Till TenderRepository that is being moved. | ID_RPSTY_TND_TL | Identity | integer | Till(AS_TL) |
WorkstationID (FK) | The unique identifier for the Workstation from which the Till is being taken. | ID_WS | Identity | integer | Workstation(AS_WS) |
SafeTenderRepositoryID (FK) | The unique identifier for the TENDER RESPOSITORY. | ID_RPSTY_TND_SF | Identity | integer | Safe(AS_SF) |
OperatorID (FK) | A unique, automatically assigned number used to identify a workstation OPERATOR. | ID_OPR | Identity | integer | Operator(PA_OPR) |
MovementDirectionCode | A code denoting the direction the Till is being moved. ie: From Safe to Workstation, From Workstation to Safe, From Safe to Operator, From Operator to Workstation, etc. | CD_MV_DRC | Code2 | char(2) | |